UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4HqJlGupGVjLwTZc4yu+z7OGSFJ5KyVNbdNN9V31Zs='
WHERE
key_id = '43fbcb47fafb8b6ede82c78ccc198db2bd25183ccb0a02b7818177a0783ee96d'
AND (
token = 'J4HqJlGupGVjLwTZc4yu+z7OGSFJ5KyVNbdNN9V31Zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)