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

Query time 0.00034