UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7ihPZ+Au7IyDfmDItvpO+SOBa7StpxAyx+k/0kqxQJM=' 
WHERE 
  key_id = '9bdb31565253838e5b662d62bbcc961d80e1853d9cf5cc0a58aba8f37acf6197' 
  AND (
    token = '7ihPZ+Au7IyDfmDItvpO+SOBa7StpxAyx+k/0kqxQJM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036