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