UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'azPZ4f88kse+5GHT1nVCGKq3sBvSiDqibDbueNn2Bfo=' 
WHERE 
  key_id = 'e1c629f757e9b8f7d8ee874961b0fbc7b7a3c224a8f2a5271a9303bca6847846' 
  AND (
    token = 'azPZ4f88kse+5GHT1nVCGKq3sBvSiDqibDbueNn2Bfo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021