UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oqWdt7HO2SZw0RRWu6v52LEhyB7AxrZGkEJVfuoMvHg='
WHERE
key_id = 'a2ff335df210a59d60812fcab6081ae5d19f1e5763e4b84e254337af77a56eea'
AND (
token = 'oqWdt7HO2SZw0RRWu6v52LEhyB7AxrZGkEJVfuoMvHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)