UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BDsNbaWZHGsSrVot5MrYlLCZzxOa93+rYB08IuIij0Q='
WHERE
key_id = '6a6ee18bf8006b473a8120e385cac82ccde06c0d78f27aa252527447c225b701'
AND (
token = 'BDsNbaWZHGsSrVot5MrYlLCZzxOa93+rYB08IuIij0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)