UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPb9cZA0+LHRoqLCc9ZuipH/dUBpW6qYTpAaxigxgC8='
WHERE
key_id = 'a0e2070f2668b073fda58e3eec5c519cda1e3c0927153aeea5c5dde900aa3002'
AND (
token = 'zPb9cZA0+LHRoqLCc9ZuipH/dUBpW6qYTpAaxigxgC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)