UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOZlyz6WkHNM52GkLOGciMNOnwj72Z4YzBOuZR8ERQA='
WHERE
key_id = '3cd24b04115d4c5c77ec1bbced2c974c9a0db7f0c5a709abdab9ef6f83d9c03e'
AND (
token = 'HOZlyz6WkHNM52GkLOGciMNOnwj72Z4YzBOuZR8ERQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)