UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ScA05X3tKh8VTzeVsB9wuRdq2QVHtmizttK7lFyrwA0='
WHERE
key_id = 'ecddbfece994a9a58386bf4df10c8f195a87be2d5d8f4208ab2e49d0ed8d0bc0'
AND (
token = 'ScA05X3tKh8VTzeVsB9wuRdq2QVHtmizttK7lFyrwA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)