UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9giQ0Q5jV7kTTgpsCIs6KkBrZy3HZT50bS9Yf/uyEGM='
WHERE
key_id = '6b28cb2f302154210502d03dd88cf285a3c3f9a904847d141f458373a7651d44'
AND (
token = '9giQ0Q5jV7kTTgpsCIs6KkBrZy3HZT50bS9Yf/uyEGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)