UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E4cLfoW0uxmmMnbyP/JwnlDefC8gsuNxdRt59wvwEe0='
WHERE
key_id = 'e885e8909485d6a3a4f6faf16becc80ddb585dae34afa7ca0e8172ff67a9d244'
AND (
token = 'E4cLfoW0uxmmMnbyP/JwnlDefC8gsuNxdRt59wvwEe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)