UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4GcRKlXS1XDbP9dE8tRKJvA1WkN1iNB4h7z2KjxA1vM=' 
WHERE 
  key_id = '156bc6349554ff00b5a7a16af6015ce01c84c2a6d59c8de48fb75a52cc41bcfc' 
  AND (
    token = '4GcRKlXS1XDbP9dE8tRKJvA1WkN1iNB4h7z2KjxA1vM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025