UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+eQKtJM64pqDFIMLNb7CrLfjjxTngT9Pta8/HqhNyU='
WHERE
key_id = '2ab49e8240348571de9cf9634af587f5124b11a025fd1b754bb443b7b7d62145'
AND (
token = 'Z+eQKtJM64pqDFIMLNb7CrLfjjxTngT9Pta8/HqhNyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)