UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQ5TemzlYwhn5F6Pf0POpjGifqOSn+Mc0vf+WS95XgE='
WHERE
key_id = '9c593c5e7845eda56c73708e731c084e4f3a03df21d08fc627aa2e11c63bffa6'
AND (
token = 'hQ5TemzlYwhn5F6Pf0POpjGifqOSn+Mc0vf+WS95XgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)