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