UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5NQbB+ykm266pX99oYif+hVvXhNZsWbUxLvMVZmdOr8='
WHERE
key_id = '047020b1621ecacae1084a36674865f5812d7ee4545ef1fbf9b230b12e17f30a'
AND (
token = '5NQbB+ykm266pX99oYif+hVvXhNZsWbUxLvMVZmdOr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)