UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UVSL+9f9svW1GFDJfcN8Mep8invixqDO1Fe7jkZWCAU='
WHERE
key_id = 'd813af9475009bbdf1a8f5e1a32186f25006c20f35164a12904a7f651a2f0788'
AND (
token = 'UVSL+9f9svW1GFDJfcN8Mep8invixqDO1Fe7jkZWCAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)