UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ph6wMtq/ClPkaZrk7FN2veXefSwhqmLGSFiVqN3A5JM='
WHERE
key_id = '507b2b2fe9a060c4a7cfff43c009326c34efb112808c5cb42b773f141883d343'
AND (
token = 'ph6wMtq/ClPkaZrk7FN2veXefSwhqmLGSFiVqN3A5JM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)