UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6IiPYcOcFKqcAgKBuXxQiGwHu4Urz7MglC8q2OEumv8='
WHERE
key_id = '10a93c645edeede697aba8ab8b53a27ebb42623c8856a8b3bf8d2bc10503aa99'
AND (
token = '6IiPYcOcFKqcAgKBuXxQiGwHu4Urz7MglC8q2OEumv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)