UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q7xYQY8e8+5siLrPoySWoH73WabT5GgmfKReUNSxDZU='
WHERE
key_id = 'a7d6ddd9bdfbbb23e11474e09a3d0a7446350fe10816ca8eea6db59a433fe746'
AND (
token = 'Q7xYQY8e8+5siLrPoySWoH73WabT5GgmfKReUNSxDZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)