UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZd4BdQn5J3rD4sAMpwVimDcqrUORle4Q3Bl7VPsAaQ='
WHERE
key_id = '8ca5c4bd9b56228c474270316381b4e9fbda0c4eea8a9b68e9a0218f8bc6c231'
AND (
token = 'bZd4BdQn5J3rD4sAMpwVimDcqrUORle4Q3Bl7VPsAaQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)