UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Th7eocGazmsUSaHiQ2LKr5tNRQeYRPU6yuzaSy7so38='
WHERE
key_id = '778343fe52e67d742bbc53c0186fcb9699187f8d7e46ba2897d424125d560670'
AND (
token = 'Th7eocGazmsUSaHiQ2LKr5tNRQeYRPU6yuzaSy7so38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)