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