UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H7rlUf5nVdRlCcWYXiWLboFmEnSgLJGa2ksgn1elIgQ='
WHERE
key_id = 'aa8ce0027494bc365770b11e6fd5b09121495f2fb6d989c70b88be6167671f73'
AND (
token = 'H7rlUf5nVdRlCcWYXiWLboFmEnSgLJGa2ksgn1elIgQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)