UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XjhICEtCwTrA8YDEDJVvYyCRaYlCMf1G9HM2H7fKQg0='
WHERE
key_id = '699adfce9223bfdab95151c1dd847b947b33138fbd3c812971a38b3e1b2ff64f'
AND (
token = 'XjhICEtCwTrA8YDEDJVvYyCRaYlCMf1G9HM2H7fKQg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)