UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xj0hho4IpOsPDUWynrnjdF4ofMJ2n2I6Ptw2ECZzl5c='
WHERE
key_id = '150f33454955332b07a67efa24a2aea5612eeb666ad921584a8f86222a02447d'
AND (
token = 'Xj0hho4IpOsPDUWynrnjdF4ofMJ2n2I6Ptw2ECZzl5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)