UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZ9Q1hWK7H9oKstWHUE1hYSZV2KZSf5bTzU5ox4qKRs='
WHERE
key_id = '6d91a7013e11a56d1573cb9260ba5ada1121d04ff41af9b8a36de337b5c58e4e'
AND (
token = 'vZ9Q1hWK7H9oKstWHUE1hYSZV2KZSf5bTzU5ox4qKRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)