UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9B605G9y0/uU8BIFxphh0zSfo1qhzFzmv9icERnjbV0='
WHERE
key_id = 'cd25a8a68249cbb1a23b13804c99776ce472544445871dac94391eb1165ac566'
AND (
token = '9B605G9y0/uU8BIFxphh0zSfo1qhzFzmv9icERnjbV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)