UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xtx8205Dx/nQg5vhOvlbg2A6LnUA3KUxo2W3ML9/Tsc='
WHERE
key_id = '46fa42987db9a1c88ddbb192def244447eec7eaaba28e6f1e0522eb7aa0bff6b'
AND (
token = 'xtx8205Dx/nQg5vhOvlbg2A6LnUA3KUxo2W3ML9/Tsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)