UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZRG9bk2Y1WYHw2xwN7jpO4DThDozJaY5jQURob3A9k='
WHERE
key_id = '7980bcf0c5e3fa92470feeae9a1a53e6f3fefec049c38d9ed3ca8660e2af5e5d'
AND (
token = 'CZRG9bk2Y1WYHw2xwN7jpO4DThDozJaY5jQURob3A9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)