UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'D9bh94lqhCImqAk1h0AA7arv4oBUNUd5hf1u3N4gZt4=' 
WHERE 
  key_id = '4372c46bf7d10603e94f05c92fb89bc8d1e9449afe1cd756f1f744caa7cb1370' 
  AND (
    token = 'D9bh94lqhCImqAk1h0AA7arv4oBUNUd5hf1u3N4gZt4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021