UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'J+RWNm4uKvNf7qjdBYEK4i79M4UMhL8oNYpPdmovx/c=' 
WHERE 
  key_id = 'c2eb09300972a261fb965198f4c7a91fd616a8fc1a04f4f8f78bb1bc8488aad2' 
  AND (
    token = 'J+RWNm4uKvNf7qjdBYEK4i79M4UMhL8oNYpPdmovx/c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021