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

Query time 0.00045