UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9xDSEX/7xnWDX7EH56ujZj+/cNzChLMUTGPytzxQQTw='
WHERE
key_id = 'fba0c18a99533cde6296c09f4cc85140aa518221de9a09d3a7a2fbd29b193391'
AND (
token = '9xDSEX/7xnWDX7EH56ujZj+/cNzChLMUTGPytzxQQTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)