UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uA9ucZHi75OKr7VaNK3BzA6BfqZO4CV9U9Sorry+o2k='
WHERE
key_id = 'f96443f40b1394962183f38e6d6cd4e229352789ec372d7fba0d50fb46e27d72'
AND (
token = 'uA9ucZHi75OKr7VaNK3BzA6BfqZO4CV9U9Sorry+o2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)