UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GBqupPoG8uTiedX8V6uJzV1N+abWHC7yvSXHNEd28U='
WHERE
key_id = 'a3cb09b822053b3201dc0b024478059ae502be2f7695b69472b28921e76d5112'
AND (
token = '9GBqupPoG8uTiedX8V6uJzV1N+abWHC7yvSXHNEd28U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)