UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '//uVg4nyFhwmWKO1U5q7aDSAdkapxG7gmxqcHNFJYts='
WHERE
key_id = 'a1e71f66894128ef51cf73038ea640847a262709b37d1d20f8ca9c77d364d2d2'
AND (
token = '//uVg4nyFhwmWKO1U5q7aDSAdkapxG7gmxqcHNFJYts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)