UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'o3qU1GGs1U561HaMyL9M19hY+8mLdrbLhvpm4HnCLWs=' 
WHERE 
  key_id = 'e35a95403e8d560fb5aa0ed2a1fcf7041e32c8ccb3b6ad15a13da8a3a711ee25' 
  AND (
    token = 'o3qU1GGs1U561HaMyL9M19hY+8mLdrbLhvpm4HnCLWs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023